CIMPLICITY REST API Web Service
CIMPLICITY REST API Web Service / SQLGetResponse Json Schema
In This Topic
SQLGetResponse Json Schema
In This Topic
Description
The results of the points get query
Overview
SQLGetResponse
The results of the points get query
SQLDefaultConnections : Array[CimSQLConnection]
An array of the CimSQLConnection objects to create/update.
ConnectionType : CimSQLConnectionType
ODBCDataSource : string
ODBC Data connection.
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
ReconnectWaitUnit : CimTimeUnitEnum
defines units for time values
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
SQLTableConnections : Array[CimSQLTableConnection]
An array of the CimSQLConnection objects to create/update.
Table_id : string
Table id on which connection is updated.
SQLConnection : CimSQLConnection
Fields that describe the connection to a SQL connection
ConnectionType : CimSQLConnectionType
ODBCDataSource : string
ODBC Data connection.
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
ReconnectWaitUnit : CimTimeUnitEnum
defines units for time values
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
Properties
NameDescriptionData Type
SQLDefaultConnectionsAn array of the CimSQLConnection objects to create/update.Array[CimSQLConnection]
SQLTableConnectionsAn array of the CimSQLConnection objects to create/update.Array[CimSQLTableConnection]
See Also
CIMPLICITY REST API Web Service

 

 

© 2021 All Rights Reserved.